Dataset statistics
| Number of variables | 32 |
|---|---|
| Number of observations | 117963 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 20.6 MiB |
| Average record size in memory | 183.1 B |
Variable types
| Numeric | 15 |
|---|---|
| Categorical | 16 |
| DateTime | 1 |
country has a high cardinality: 177 distinct values | High cardinality |
arrival_date_year is highly correlated with arrival_date_month and 1 other fields | High correlation |
arrival_date_month is highly correlated with arrival_date_year and 1 other fields | High correlation |
arrival_date_week_number is highly correlated with arrival_date_year and 1 other fields | High correlation |
stays_in_weekend_nights is highly correlated with stay | High correlation |
stays_in_week_nights is highly correlated with stay | High correlation |
is_repeated_guest is highly correlated with previous_bookings_not_canceled | High correlation |
previous_bookings_not_canceled is highly correlated with is_repeated_guest | High correlation |
stay is highly correlated with stays_in_weekend_nights and 1 other fields | High correlation |
arrival_date_year is highly correlated with arrival_date_month and 1 other fields | High correlation |
arrival_date_month is highly correlated with arrival_date_year and 1 other fields | High correlation |
arrival_date_week_number is highly correlated with arrival_date_year and 1 other fields | High correlation |
stays_in_weekend_nights is highly correlated with stay | High correlation |
stays_in_week_nights is highly correlated with stay | High correlation |
stay is highly correlated with stays_in_weekend_nights and 1 other fields | High correlation |
arrival_date_month is highly correlated with arrival_date_week_number | High correlation |
arrival_date_week_number is highly correlated with arrival_date_month | High correlation |
stays_in_weekend_nights is highly correlated with stay | High correlation |
stays_in_week_nights is highly correlated with stay | High correlation |
is_repeated_guest is highly correlated with previous_bookings_not_canceled | High correlation |
previous_bookings_not_canceled is highly correlated with is_repeated_guest | High correlation |
stay is highly correlated with stays_in_weekend_nights and 1 other fields | High correlation |
is_canceled is highly correlated with reservation_status | High correlation |
reservation_status is highly correlated with is_canceled | High correlation |
distribution_channel is highly correlated with market_segment | High correlation |
reserved_room_type is highly correlated with assigned_room_type | High correlation |
assigned_room_type is highly correlated with reserved_room_type | High correlation |
market_segment is highly correlated with distribution_channel | High correlation |
df_index is highly correlated with hotel and 6 other fields | High correlation |
hotel is highly correlated with df_index | High correlation |
is_canceled is highly correlated with df_index and 1 other fields | High correlation |
arrival_date_year is highly correlated with df_index and 3 other fields | High correlation |
arrival_date_month is highly correlated with df_index and 3 other fields | High correlation |
arrival_date_week_number is highly correlated with df_index and 2 other fields | High correlation |
stays_in_weekend_nights is highly correlated with stays_in_week_nights and 1 other fields | High correlation |
stays_in_week_nights is highly correlated with stays_in_weekend_nights and 1 other fields | High correlation |
children is highly correlated with reserved_room_type and 1 other fields | High correlation |
market_segment is highly correlated with distribution_channel | High correlation |
distribution_channel is highly correlated with market_segment | High correlation |
previous_cancellations is highly correlated with previous_bookings_not_canceled | High correlation |
previous_bookings_not_canceled is highly correlated with previous_cancellations | High correlation |
reserved_room_type is highly correlated with children and 2 other fields | High correlation |
assigned_room_type is highly correlated with children and 1 other fields | High correlation |
deposit_type is highly correlated with reservation_status | High correlation |
adr is highly correlated with arrival_date_month and 1 other fields | High correlation |
reservation_status is highly correlated with df_index and 2 other fields | High correlation |
reservation_status_date is highly correlated with df_index and 1 other fields | High correlation |
stay is highly correlated with stays_in_weekend_nights and 1 other fields | High correlation |
previous_cancellations is highly skewed (γ1 = 24.33573338) | Skewed |
previous_bookings_not_canceled is highly skewed (γ1 = 24.00883198) | Skewed |
df_index has unique values | Unique |
lead_time has 5912 (5.0%) zeros | Zeros |
stays_in_weekend_nights has 50976 (43.2%) zeros | Zeros |
stays_in_week_nights has 6892 (5.8%) zeros | Zeros |
previous_cancellations has 111526 (94.5%) zeros | Zeros |
previous_bookings_not_canceled has 114601 (97.1%) zeros | Zeros |
booking_changes has 100169 (84.9%) zeros | Zeros |
days_in_waiting_list has 114267 (96.9%) zeros | Zeros |
adr has 1227 (1.0%) zeros | Zeros |
total_of_special_requests has 69417 (58.8%) zeros | Zeros |
Reproduction
| Analysis started | 2022-02-07 07:16:14.208126 |
|---|---|
| Analysis finished | 2022-02-07 07:16:56.666686 |
| Duration | 42.46 seconds |
| Software version | pandas-profiling v3.1.0 |
| Download configuration | config.json |
| Distinct | 117963 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59963.03778 |
| Minimum | 2 |
|---|---|
| Maximum | 119389 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 6012.1 |
| Q1 | 30352.5 |
| median | 60053 |
| Q3 | 89709.5 |
| 95-th percentile | 113480.9 |
| Maximum | 119389 |
| Range | 119387 |
| Interquartile range (IQR) | 59357 |
Descriptive statistics
| Standard deviation | 34387.63698 |
|---|---|
| Coefficient of variation (CV) | 0.5734805681 |
| Kurtosis | -1.190833738 |
| Mean | 59963.03778 |
| Median Absolute Deviation (MAD) | 29679 |
| Skewness | -0.009467411338 |
| Sum | 7073419826 |
| Variance | 1182509577 |
| Monotonicity | Strictly increasing |
| Value | Count | Frequency (%) |
| 2 | 1 | < 0.1% |
| 79775 | 1 | < 0.1% |
| 79773 | 1 | < 0.1% |
| 79772 | 1 | < 0.1% |
| 79771 | 1 | < 0.1% |
| 79770 | 1 | < 0.1% |
| 79769 | 1 | < 0.1% |
| 79768 | 1 | < 0.1% |
| 79767 | 1 | < 0.1% |
| 79766 | 1 | < 0.1% |
| Other values (117953) | 117953 |
| Value | Count | Frequency (%) |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 8 | 1 | |
| 9 | 1 | |
| 10 | 1 | |
| 11 | 1 |
| Value | Count | Frequency (%) |
| 119389 | 1 | |
| 119388 | 1 | |
| 119387 | 1 | |
| 119386 | 1 | |
| 119385 | 1 | |
| 119384 | 1 | |
| 119383 | 1 | |
| 119382 | 1 | |
| 119381 | 1 | |
| 119380 | 1 |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.4 KiB |
| City Hotel | |
|---|---|
| Resort Hotel |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 10.66208896 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Resort Hotel |
|---|---|
| 2nd row | Resort Hotel |
| 3rd row | Resort Hotel |
| 4th row | Resort Hotel |
| 5th row | Resort Hotel |
Common Values
| Value | Count | Frequency (%) |
| City Hotel | 78912 | |
| Resort Hotel | 39051 |
Length
Pie chart
| Value | Count | Frequency (%) |
| hotel | 117963 | |
| city | 78912 | |
| resort | 39051 | 16.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 921.7 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 73959 | |
| 1 | 44004 |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 73959 | |
| 1 | 44004 |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 476 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 104.7351627 |
| Minimum | 0 |
|---|---|
| Maximum | 629 |
| Zeros | 5912 |
| Zeros (%) | 5.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 19 |
| median | 70 |
| Q3 | 161 |
| 95-th percentile | 320 |
| Maximum | 629 |
| Range | 629 |
| Interquartile range (IQR) | 142 |
Descriptive statistics
| Standard deviation | 106.9707854 |
|---|---|
| Coefficient of variation (CV) | 1.021345483 |
| Kurtosis | 1.667113783 |
| Mean | 104.7351627 |
| Median Absolute Deviation (MAD) | 60 |
| Skewness | 1.339451744 |
| Sum | 12354874 |
| Variance | 11442.74893 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 5912 | 5.0% |
| 1 | 3330 | 2.8% |
| 2 | 2008 | 1.7% |
| 3 | 1788 | 1.5% |
| 4 | 1683 | 1.4% |
| 5 | 1538 | 1.3% |
| 6 | 1408 | 1.2% |
| 7 | 1301 | 1.1% |
| 8 | 1116 | 0.9% |
| 12 | 1068 | 0.9% |
| Other values (466) | 96811 |
| Value | Count | Frequency (%) |
| 0 | 5912 | |
| 1 | 3330 | |
| 2 | 2008 | 1.7% |
| 3 | 1788 | 1.5% |
| 4 | 1683 | 1.4% |
| 5 | 1538 | 1.3% |
| 6 | 1408 | 1.2% |
| 7 | 1301 | 1.1% |
| 8 | 1116 | 0.9% |
| 9 | 975 | 0.8% |
| Value | Count | Frequency (%) |
| 629 | 17 | |
| 626 | 30 | |
| 622 | 17 | |
| 615 | 17 | |
| 608 | 17 | |
| 605 | 30 | |
| 601 | 17 | |
| 594 | 17 | |
| 587 | 17 | |
| 580 | 17 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 921.7 KiB |
| 2016 | |
|---|---|
| 2017 | |
| 2015 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2015 |
| 4th row | 2015 |
| 5th row | 2015 |
Common Values
| Value | Count | Frequency (%) |
| 2016 | 55936 | |
| 2017 | 40352 | |
| 2015 | 21675 | 18.4% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 2016 | 55936 | |
| 2017 | 40352 | |
| 2015 | 21675 | 18.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
arrival_date_month
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.555513169 |
| Minimum | 1 |
|---|---|
| Maximum | 12 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 460.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 4 |
| median | 7 |
| Q3 | 9 |
| 95-th percentile | 12 |
| Maximum | 12 |
| Range | 11 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.081294038 |
|---|---|
| Coefficient of variation (CV) | 0.4700309432 |
| Kurtosis | -0.9873507447 |
| Mean | 6.555513169 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.02876489093 |
| Sum | 773308 |
| Variance | 9.494372951 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 8 | 13796 | |
| 7 | 12560 | |
| 5 | 11698 | |
| 4 | 11007 | |
| 10 | 10993 | |
| 6 | 10879 | |
| 9 | 10435 | |
| 3 | 9601 | |
| 2 | 7908 | |
| 11 | 6666 | |
| Other values (2) | 12420 |
| Value | Count | Frequency (%) |
| 1 | 5782 | |
| 2 | 7908 | |
| 3 | 9601 | |
| 4 | 11007 | |
| 5 | 11698 | |
| 6 | 10879 | |
| 7 | 12560 | |
| 8 | 13796 | |
| 9 | 10435 | |
| 10 | 10993 |
| Value | Count | Frequency (%) |
| 12 | 6638 | |
| 11 | 6666 | |
| 10 | 10993 | |
| 9 | 10435 | |
| 8 | 13796 | |
| 7 | 12560 | |
| 6 | 10879 | |
| 5 | 11698 | |
| 4 | 11007 | |
| 3 | 9601 |
arrival_date_week_number
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATION| Distinct | 53 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.17869162 |
| Minimum | 1 |
|---|---|
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 16 |
| median | 28 |
| Q3 | 38 |
| 95-th percentile | 49 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 22 |
Descriptive statistics
| Standard deviation | 13.56348511 |
|---|---|
| Coefficient of variation (CV) | 0.4990484936 |
| Kurtosis | -0.9787054744 |
| Mean | 27.17869162 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.01082883282 |
| Sum | 3206080 |
| Variance | 183.9681284 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 33 | 3557 | 3.0% |
| 30 | 3062 | 2.6% |
| 34 | 3027 | 2.6% |
| 32 | 3024 | 2.6% |
| 18 | 2894 | 2.5% |
| 28 | 2829 | 2.4% |
| 21 | 2811 | 2.4% |
| 17 | 2800 | 2.4% |
| 20 | 2773 | 2.4% |
| 29 | 2746 | 2.3% |
| Other values (43) | 88440 |
| Value | Count | Frequency (%) |
| 1 | 1029 | |
| 2 | 1193 | |
| 3 | 1275 | |
| 4 | 1447 | |
| 5 | 1352 | |
| 6 | 1466 | |
| 7 | 2066 | |
| 8 | 2189 | |
| 9 | 2038 | |
| 10 | 2105 |
| Value | Count | Frequency (%) |
| 53 | 1798 | |
| 52 | 1165 | |
| 51 | 890 | |
| 50 | 1469 | |
| 49 | 1761 | |
| 48 | 1469 | |
| 47 | 1659 | |
| 46 | 1538 | |
| 45 | 1911 | |
| 44 | 2220 |
arrival_date_day_of_month
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.81058467 |
| Minimum | 1 |
|---|---|
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 30 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.778873094 |
|---|---|
| Coefficient of variation (CV) | 0.5552529065 |
| Kurtosis | -1.187186386 |
| Mean | 15.81058467 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.003431509956 |
| Sum | 1865064 |
| Variance | 77.06861281 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 17 | 4330 | 3.7% |
| 5 | 4264 | 3.6% |
| 15 | 4124 | 3.5% |
| 25 | 4118 | 3.5% |
| 26 | 4102 | 3.5% |
| 9 | 4053 | 3.4% |
| 12 | 4050 | 3.4% |
| 16 | 4035 | 3.4% |
| 19 | 4025 | 3.4% |
| 2 | 4010 | 3.4% |
| Other values (21) | 76852 |
| Value | Count | Frequency (%) |
| 1 | 3545 | |
| 2 | 4010 | |
| 3 | 3807 | |
| 4 | 3703 | |
| 5 | 4264 | |
| 6 | 3784 | |
| 7 | 3623 | |
| 8 | 3864 | |
| 9 | 4053 | |
| 10 | 3529 |
| Value | Count | Frequency (%) |
| 31 | 2189 | |
| 30 | 3809 | |
| 29 | 3543 | |
| 28 | 3903 | |
| 27 | 3758 | |
| 26 | 4102 | |
| 25 | 4118 | |
| 24 | 3951 | |
| 23 | 3577 | |
| 22 | 3563 |
stays_in_weekend_nights
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.9219924892 |
| Minimum | 0 |
|---|---|
| Maximum | 6 |
| Zeros | 50976 |
| Zeros (%) | 43.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 6 |
| Range | 6 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 0.953329183 |
|---|---|
| Coefficient of variation (CV) | 1.033988014 |
| Kurtosis | 0.2219074172 |
| Mean | 0.9219924892 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.7471127314 |
| Sum | 108761 |
| Variance | 0.9088365311 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 50976 | |
| 2 | 33249 | |
| 1 | 30526 | |
| 4 | 1849 | 1.6% |
| 3 | 1253 | 1.1% |
| 5 | 78 | 0.1% |
| 6 | 32 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 50976 | |
| 1 | 30526 | |
| 2 | 33249 | |
| 3 | 1253 | 1.1% |
| 4 | 1849 | 1.6% |
| 5 | 78 | 0.1% |
| 6 | 32 | < 0.1% |
| Value | Count | Frequency (%) |
| 6 | 32 | < 0.1% |
| 5 | 78 | 0.1% |
| 4 | 1849 | 1.6% |
| 3 | 1253 | 1.1% |
| 2 | 33249 | |
| 1 | 30526 | |
| 0 | 50976 |
stays_in_week_nights
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONZEROS| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.485075829 |
| Minimum | 0 |
|---|---|
| Maximum | 15 |
| Zeros | 6892 |
| Zeros (%) | 5.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 15 |
| Range | 15 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.743486635 |
|---|---|
| Coefficient of variation (CV) | 0.7015828712 |
| Kurtosis | 4.03256695 |
| Mean | 2.485075829 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.513946426 |
| Sum | 293147 |
| Variance | 3.039745647 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 33574 | |
| 1 | 30088 | |
| 3 | 22203 | |
| 5 | 11051 | 9.4% |
| 4 | 9554 | 8.1% |
| 0 | 6892 | 5.8% |
| 6 | 1491 | 1.3% |
| 10 | 1030 | 0.9% |
| 7 | 1027 | 0.9% |
| 8 | 654 | 0.6% |
| Other values (6) | 399 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 6892 | 5.8% |
| 1 | 30088 | |
| 2 | 33574 | |
| 3 | 22203 | |
| 4 | 9554 | 8.1% |
| 5 | 11051 | 9.4% |
| 6 | 1491 | 1.3% |
| 7 | 1027 | 0.9% |
| 8 | 654 | 0.6% |
| 9 | 231 | 0.2% |
| Value | Count | Frequency (%) |
| 15 | 9 | < 0.1% |
| 14 | 35 | < 0.1% |
| 13 | 27 | < 0.1% |
| 12 | 42 | < 0.1% |
| 11 | 55 | < 0.1% |
| 10 | 1030 | |
| 9 | 231 | 0.2% |
| 8 | 654 | |
| 7 | 1027 | |
| 6 | 1491 |
adults
Real number (ℝ≥0)
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.860362995 |
| Minimum | 0 |
|---|---|
| Maximum | 55 |
| Zeros | 325 |
| Zeros (%) | 0.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 2 |
| Q3 | 2 |
| 95-th percentile | 3 |
| Maximum | 55 |
| Range | 55 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.5775354861 |
|---|---|
| Coefficient of variation (CV) | 0.310442364 |
| Kurtosis | 1384.363683 |
| Mean | 1.860362995 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 18.72070574 |
| Sum | 219454 |
| Variance | 0.3335472377 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 88895 | |
| 1 | 22487 | 19.1% |
| 3 | 6178 | 5.2% |
| 0 | 325 | 0.3% |
| 4 | 62 | 0.1% |
| 26 | 5 | < 0.1% |
| 27 | 2 | < 0.1% |
| 20 | 2 | < 0.1% |
| 5 | 2 | < 0.1% |
| 40 | 1 | < 0.1% |
| Other values (4) | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 325 | 0.3% |
| 1 | 22487 | 19.1% |
| 2 | 88895 | |
| 3 | 6178 | 5.2% |
| 4 | 62 | 0.1% |
| 5 | 2 | < 0.1% |
| 6 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| 20 | 2 | < 0.1% |
| 26 | 5 | < 0.1% |
| Value | Count | Frequency (%) |
| 55 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 40 | 1 | < 0.1% |
| 27 | 2 | < 0.1% |
| 26 | 5 | < 0.1% |
| 20 | 2 | < 0.1% |
| 10 | 1 | < 0.1% |
| 6 | 1 | < 0.1% |
| 5 | 2 | < 0.1% |
| 4 | 62 |
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 921.7 KiB |
| 0 | |
|---|---|
| 1 | 4830 |
| 2 | 3629 |
| 3 | 76 |
| 10 | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.000008477 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 109427 | |
| 1 | 4830 | 4.1% |
| 2 | 3629 | 3.1% |
| 3 | 76 | 0.1% |
| 10 | 1 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 109427 | |
| 1 | 4830 | 4.1% |
| 2 | 3629 | 3.1% |
| 3 | 76 | 0.1% |
| 10 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
babies
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 921.7 KiB |
| 0 | |
|---|---|
| 1 | 893 |
| 2 | 14 |
| 10 | 1 |
| 9 | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.000008477 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 117054 | |
| 1 | 893 | 0.8% |
| 2 | 14 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 117054 | |
| 1 | 893 | 0.8% |
| 2 | 14 | < 0.1% |
| 10 | 1 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
meal
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.5 KiB |
| BB | |
|---|---|
| HB | |
| SC | |
| Undefined | 1150 |
| FB | 797 |
Length
| Max length | 9 |
|---|---|
| Median length | 2 |
| Mean length | 2.068241737 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BB |
|---|---|
| 2nd row | BB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
Common Values
| Value | Count | Frequency (%) |
| BB | 91202 | |
| HB | 14270 | 12.1% |
| SC | 10544 | 8.9% |
| Undefined | 1150 | 1.0% |
| FB | 797 | 0.7% |
Length
Pie chart
| Value | Count | Frequency (%) |
| bb | 91202 | |
| hb | 14270 | 12.1% |
| sc | 10544 | 8.9% |
| undefined | 1150 | 1.0% |
| fb | 797 | 0.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 177 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 236.0 KiB |
| PRT | |
|---|---|
| GBR | |
| FRA | |
| ESP | |
| DEU | |
| Other values (172) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.989310207 |
| Min length | 2 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 30 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | GBR |
|---|---|
| 2nd row | GBR |
| 3rd row | GBR |
| 4th row | GBR |
| 5th row | PRT |
Common Values
| Value | Count | Frequency (%) |
| PRT | 47892 | |
| GBR | 12072 | 10.2% |
| FRA | 10389 | 8.8% |
| ESP | 8550 | 7.2% |
| DEU | 7276 | 6.2% |
| ITA | 3759 | 3.2% |
| IRL | 3372 | 2.9% |
| BEL | 2334 | 2.0% |
| BRA | 2216 | 1.9% |
| NLD | 2097 | 1.8% |
| Other values (167) | 18006 | 15.3% |
Length
| Value | Count | Frequency (%) |
| prt | 47892 | |
| gbr | 12072 | 10.2% |
| fra | 10389 | 8.8% |
| esp | 8550 | 7.2% |
| deu | 7276 | 6.2% |
| ita | 3759 | 3.2% |
| irl | 3372 | 2.9% |
| bel | 2334 | 2.0% |
| bra | 2216 | 1.9% |
| nld | 2097 | 1.8% |
| Other values (167) | 18006 | 15.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Groups | |
| Direct | |
| Corporate | 5050 |
| Other values (2) | 948 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.020794656 |
| Min length | 6 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Corporate |
| 3rd row | Online TA |
| 4th row | Online TA |
| 5th row | Direct |
Common Values
| Value | Count | Frequency (%) |
| Online TA | 56004 | |
| Offline TA/TO | 23957 | |
| Groups | 19714 | 16.7% |
| Direct | 12290 | 10.4% |
| Corporate | 5050 | 4.3% |
| Complementary | 717 | 0.6% |
| Aviation | 231 | 0.2% |
Length
Pie chart
| Value | Count | Frequency (%) |
| online | 56004 | |
| ta | 56004 | |
| offline | 23957 | |
| ta/to | 23957 | |
| groups | 19714 | 10.0% |
| direct | 12290 | 6.2% |
| corporate | 5050 | 2.6% |
| complementary | 717 | 0.4% |
| aviation | 231 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.5 KiB |
| TA/TO | |
|---|---|
| Direct | |
| Corporate | 6405 |
| GDS | 189 |
| Undefined | 1 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.335189848 |
| Min length | 3 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Direct |
|---|---|
| 2nd row | Corporate |
| 3rd row | TA/TO |
| 4th row | TA/TO |
| 5th row | Direct |
Common Values
| Value | Count | Frequency (%) |
| TA/TO | 97074 | |
| Direct | 14294 | 12.1% |
| Corporate | 6405 | 5.4% |
| GDS | 189 | 0.2% |
| Undefined | 1 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| ta/to | 97074 | |
| direct | 14294 | 12.1% |
| corporate | 6405 | 5.4% |
| gds | 189 | 0.2% |
| undefined | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 921.7 KiB |
| 0 | |
|---|---|
| 1 | 3497 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 114466 | |
| 1 | 3497 | 3.0% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 114466 | |
| 1 | 3497 | 3.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.08773089867 |
| Minimum | 0 |
|---|---|
| Maximum | 26 |
| Zeros | 111526 |
| Zeros (%) | 94.5% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 26 |
| Range | 26 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.8491095557 |
|---|---|
| Coefficient of variation (CV) | 9.678568994 |
| Kurtosis | 666.9137839 |
| Mean | 0.08773089867 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.33573338 |
| Sum | 10349 |
| Variance | 0.7209870376 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 111526 | |
| 1 | 6009 | 5.1% |
| 2 | 111 | 0.1% |
| 3 | 65 | 0.1% |
| 24 | 48 | < 0.1% |
| 11 | 35 | < 0.1% |
| 4 | 31 | < 0.1% |
| 26 | 26 | < 0.1% |
| 25 | 25 | < 0.1% |
| 6 | 22 | < 0.1% |
| Other values (5) | 65 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 111526 | |
| 1 | 6009 | 5.1% |
| 2 | 111 | 0.1% |
| 3 | 65 | 0.1% |
| 4 | 31 | < 0.1% |
| 5 | 19 | < 0.1% |
| 6 | 22 | < 0.1% |
| 11 | 35 | < 0.1% |
| 13 | 12 | < 0.1% |
| 14 | 14 | < 0.1% |
| Value | Count | Frequency (%) |
| 26 | 26 | |
| 25 | 25 | |
| 24 | 48 | |
| 21 | 1 | < 0.1% |
| 19 | 19 | < 0.1% |
| 14 | 14 | < 0.1% |
| 13 | 12 | < 0.1% |
| 11 | 35 | |
| 6 | 22 | |
| 5 | 19 | < 0.1% |
previous_bookings_not_canceled
Real number (ℝ≥0)
HIGH CORRELATIONHIGH CORRELATIONHIGH CORRELATIONSKEWEDZEROS| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1318803354 |
| Minimum | 0 |
|---|---|
| Maximum | 72 |
| Zeros | 114601 |
| Zeros (%) | 97.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 72 |
| Range | 72 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.488793064 |
|---|---|
| Coefficient of variation (CV) | 11.28896935 |
| Kurtosis | 791.8969061 |
| Mean | 0.1318803354 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 24.00883198 |
| Sum | 15557 |
| Variance | 2.216504786 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 114601 | |
| 1 | 1432 | 1.2% |
| 2 | 531 | 0.5% |
| 3 | 299 | 0.3% |
| 4 | 206 | 0.2% |
| 5 | 169 | 0.1% |
| 6 | 109 | 0.1% |
| 7 | 84 | 0.1% |
| 8 | 67 | 0.1% |
| 9 | 57 | < 0.1% |
| Other values (63) | 408 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 114601 | |
| 1 | 1432 | 1.2% |
| 2 | 531 | 0.5% |
| 3 | 299 | 0.3% |
| 4 | 206 | 0.2% |
| 5 | 169 | 0.1% |
| 6 | 109 | 0.1% |
| 7 | 84 | 0.1% |
| 8 | 67 | 0.1% |
| 9 | 57 | < 0.1% |
| Value | Count | Frequency (%) |
| 72 | 1 | |
| 71 | 1 | |
| 70 | 1 | |
| 69 | 1 | |
| 68 | 1 | |
| 67 | 1 | |
| 66 | 1 | |
| 65 | 1 | |
| 64 | 1 | |
| 63 | 1 |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
| A | |
|---|---|
| D | |
| E | 6418 |
| F | 2870 |
| G | 2060 |
| Other values (4) | 2634 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | C |
Common Values
| Value | Count | Frequency (%) |
| A | 84944 | |
| D | 19037 | 16.1% |
| E | 6418 | 5.4% |
| F | 2870 | 2.4% |
| G | 2060 | 1.7% |
| B | 1109 | 0.9% |
| C | 922 | 0.8% |
| H | 597 | 0.5% |
| L | 6 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| a | 84944 | |
| d | 19037 | 16.1% |
| e | 6418 | 5.4% |
| f | 2870 | 2.4% |
| g | 2060 | 1.7% |
| b | 1109 | 0.9% |
| c | 922 | 0.8% |
| h | 597 | 0.5% |
| l | 6 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 11 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.7 KiB |
| A | |
|---|---|
| D | |
| E | |
| F | 3701 |
| G | 2511 |
| Other values (6) | 5575 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | C |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | C |
Common Values
| Value | Count | Frequency (%) |
| A | 73500 | |
| D | 25011 | 21.2% |
| E | 7665 | 6.5% |
| F | 3701 | 3.1% |
| G | 2511 | 2.1% |
| C | 2328 | 2.0% |
| B | 2146 | 1.8% |
| H | 704 | 0.6% |
| I | 213 | 0.2% |
| K | 183 | 0.2% |
Length
| Value | Count | Frequency (%) |
| a | 73500 | |
| d | 25011 | 21.2% |
| e | 7665 | 6.5% |
| f | 3701 | 3.1% |
| g | 2511 | 2.1% |
| c | 2328 | 2.0% |
| b | 2146 | 1.8% |
| h | 704 | 0.6% |
| i | 213 | 0.2% |
| k | 183 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 19 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.2192721447 |
| Minimum | 0 |
|---|---|
| Maximum | 18 |
| Zeros | 100169 |
| Zeros (%) | 84.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 18 |
| Range | 18 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6386015147 |
|---|---|
| Coefficient of variation (CV) | 2.912369538 |
| Kurtosis | 59.37769424 |
| Mean | 0.2192721447 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 5.374868144 |
| Sum | 25866 |
| Variance | 0.4078118946 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 100169 | |
| 1 | 12508 | 10.6% |
| 2 | 3749 | 3.2% |
| 3 | 918 | 0.8% |
| 4 | 370 | 0.3% |
| 5 | 113 | 0.1% |
| 6 | 60 | 0.1% |
| 7 | 29 | < 0.1% |
| 8 | 17 | < 0.1% |
| 9 | 8 | < 0.1% |
| Other values (9) | 22 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 100169 | |
| 1 | 12508 | 10.6% |
| 2 | 3749 | 3.2% |
| 3 | 918 | 0.8% |
| 4 | 370 | 0.3% |
| 5 | 113 | 0.1% |
| 6 | 60 | 0.1% |
| 7 | 29 | < 0.1% |
| 8 | 17 | < 0.1% |
| 9 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 18 | 1 | < 0.1% |
| 17 | 1 | < 0.1% |
| 16 | 2 | < 0.1% |
| 15 | 3 | < 0.1% |
| 14 | 3 | < 0.1% |
| 13 | 4 | |
| 12 | 1 | < 0.1% |
| 11 | 2 | < 0.1% |
| 10 | 5 | |
| 9 | 8 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.5 KiB |
| No Deposit | |
|---|---|
| Non Refund | |
| Refundable | 162 |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
Common Values
| Value | Count | Frequency (%) |
| No Deposit | 103249 | |
| Non Refund | 14552 | 12.3% |
| Refundable | 162 | 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| no | 103249 | |
| deposit | 103249 | |
| non | 14552 | 6.2% |
| refund | 14552 | 6.2% |
| refundable | 162 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 127 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.348083721 |
| Minimum | 0 |
|---|---|
| Maximum | 391 |
| Zeros | 114267 |
| Zeros (%) | 96.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 391 |
| Range | 391 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 17.69648405 |
|---|---|
| Coefficient of variation (CV) | 7.536564343 |
| Kurtosis | 184.6289963 |
| Mean | 2.348083721 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.87555273 |
| Sum | 276987 |
| Variance | 313.1655477 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 114267 | |
| 39 | 227 | 0.2% |
| 58 | 164 | 0.1% |
| 44 | 141 | 0.1% |
| 31 | 127 | 0.1% |
| 35 | 96 | 0.1% |
| 46 | 94 | 0.1% |
| 69 | 89 | 0.1% |
| 63 | 83 | 0.1% |
| 50 | 80 | 0.1% |
| Other values (117) | 2595 | 2.2% |
| Value | Count | Frequency (%) |
| 0 | 114267 | |
| 1 | 12 | < 0.1% |
| 2 | 5 | < 0.1% |
| 3 | 59 | 0.1% |
| 4 | 25 | < 0.1% |
| 5 | 8 | < 0.1% |
| 6 | 16 | < 0.1% |
| 7 | 4 | < 0.1% |
| 8 | 7 | < 0.1% |
| 9 | 16 | < 0.1% |
| Value | Count | Frequency (%) |
| 391 | 45 | |
| 379 | 15 | < 0.1% |
| 330 | 15 | < 0.1% |
| 259 | 10 | < 0.1% |
| 236 | 35 | |
| 224 | 10 | < 0.1% |
| 223 | 61 | |
| 215 | 21 | < 0.1% |
| 207 | 15 | < 0.1% |
| 193 | 1 | < 0.1% |
customer_type
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.5 KiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 4043 |
| Group | 565 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 10.21535566 |
| Min length | 5 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient |
|---|---|
| 2nd row | Transient |
| 3rd row | Transient |
| 4th row | Transient |
| 5th row | Transient |
Common Values
| Value | Count | Frequency (%) |
| Transient | 88410 | |
| Transient-Party | 24945 | 21.1% |
| Contract | 4043 | 3.4% |
| Group | 565 | 0.5% |
Length
Pie chart
| Value | Count | Frequency (%) |
| transient | 88410 | |
| transient-party | 24945 | 21.1% |
| contract | 4043 | 3.4% |
| group | 565 | 0.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 8832 |
|---|---|
| Distinct (%) | 7.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 102.6252728 |
| Minimum | -6.38 |
|---|---|
| Maximum | 451.5 |
| Zeros | 1227 |
| Zeros (%) | 1.0% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | -6.38 |
|---|---|
| 5-th percentile | 40 |
| Q1 | 70 |
| median | 95 |
| Q3 | 126 |
| 95-th percentile | 194 |
| Maximum | 451.5 |
| Range | 457.88 |
| Interquartile range (IQR) | 56 |
Descriptive statistics
| Standard deviation | 47.55466702 |
|---|---|
| Coefficient of variation (CV) | 0.4633816379 |
| Kurtosis | 2.141034062 |
| Mean | 102.6252728 |
| Median Absolute Deviation (MAD) | 27.5 |
| Skewness | 1.071656617 |
| Sum | 12105985.06 |
| Variance | 2261.446355 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 62 | 3751 | 3.2% |
| 75 | 2710 | 2.3% |
| 90 | 2471 | 2.1% |
| 65 | 2394 | 2.0% |
| 80 | 1887 | 1.6% |
| 95 | 1660 | 1.4% |
| 120 | 1607 | 1.4% |
| 100 | 1573 | 1.3% |
| 85 | 1537 | 1.3% |
| 110 | 1523 | 1.3% |
| Other values (8822) | 96850 |
| Value | Count | Frequency (%) |
| -6.38 | 1 | < 0.1% |
| 0 | 1227 | |
| 0.5 | 1 | < 0.1% |
| 1 | 15 | < 0.1% |
| 1.29 | 1 | < 0.1% |
| 1.48 | 1 | < 0.1% |
| 1.56 | 2 | < 0.1% |
| 1.6 | 1 | < 0.1% |
| 1.8 | 1 | < 0.1% |
| 2 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 451.5 | 1 | |
| 450 | 1 | |
| 437 | 1 | |
| 426.25 | 1 | |
| 402 | 1 | |
| 397.38 | 1 | |
| 392 | 2 | |
| 388 | 2 | |
| 387 | 1 | |
| 384 | 1 |
required_car_parking_spaces
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 921.7 KiB |
| 0 | |
|---|---|
| 1 | 7254 |
| 2 | 26 |
| 3 | 3 |
| 8 | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 110678 | |
| 1 | 7254 | 6.1% |
| 2 | 26 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Length
Pie chart
| Value | Count | Frequency (%) |
| 0 | 110678 | |
| 1 | 7254 | 6.1% |
| 2 | 26 | < 0.1% |
| 3 | 3 | < 0.1% |
| 8 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5722302756 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 69417 |
| Zeros (%) | 58.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7931765082 |
|---|---|
| Coefficient of variation (CV) | 1.386114196 |
| Kurtosis | 1.47745868 |
| Mean | 0.5722302756 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.345989519 |
| Sum | 67502 |
| Variance | 0.6291289732 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 69417 | |
| 1 | 32851 | |
| 2 | 12848 | 10.9% |
| 3 | 2471 | 2.1% |
| 4 | 338 | 0.3% |
| 5 | 38 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 69417 | |
| 1 | 32851 | |
| 2 | 12848 | 10.9% |
| 3 | 2471 | 2.1% |
| 4 | 338 | 0.3% |
| 5 | 38 | < 0.1% |
| Value | Count | Frequency (%) |
| 5 | 38 | < 0.1% |
| 4 | 338 | 0.3% |
| 3 | 2471 | 2.1% |
| 2 | 12848 | 10.9% |
| 1 | 32851 | |
| 0 | 69417 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 115.5 KiB |
| Check-Out | |
|---|---|
| Canceled | |
| No-Show | 1179 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.616973119 |
| Min length | 7 |
Characters and Unicode
| Total characters | 0 |
|---|---|
| Distinct characters | 0 |
| Distinct categories | 0 ? |
| Distinct scripts | 0 ? |
| Distinct blocks | 0 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Check-Out |
|---|---|
| 2nd row | Check-Out |
| 3rd row | Check-Out |
| 4th row | Check-Out |
| 5th row | Check-Out |
Common Values
| Value | Count | Frequency (%) |
| Check-Out | 73959 | |
| Canceled | 42825 | |
| No-Show | 1179 | 1.0% |
Length
Pie chart
| Value | Count | Frequency (%) |
| check-out | 73959 | |
| canceled | 42825 | |
| no-show | 1179 | 1.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| No values found. | ||
Most occurring categories
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per category
Most occurring scripts
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per script
Most occurring blocks
| Value | Count | Frequency (%) |
| No values found. | ||
Most frequent character per block
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 921.7 KiB |
| Minimum | 2014-01-01 00:00:00 |
|---|---|
| Maximum | 2017-01-01 00:00:00 |
| Distinct | 20 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.407068318 |
| Minimum | 1 |
|---|---|
| Maximum | 20 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 921.7 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 4 |
| 95-th percentile | 7 |
| Maximum | 20 |
| Range | 19 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.317633401 |
|---|---|
| Coefficient of variation (CV) | 0.6802427144 |
| Kurtosis | 5.261663905 |
| Mean | 3.407068318 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.866688871 |
| Sum | 401908 |
| Variance | 5.371424581 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 27529 | |
| 3 | 27025 | |
| 1 | 20793 | |
| 4 | 17363 | |
| 7 | 8633 | 7.3% |
| 5 | 7765 | 6.6% |
| 6 | 3850 | 3.3% |
| 8 | 1157 | 1.0% |
| 10 | 1135 | 1.0% |
| 14 | 913 | 0.8% |
| Other values (10) | 1800 | 1.5% |
| Value | Count | Frequency (%) |
| 1 | 20793 | |
| 2 | 27529 | |
| 3 | 27025 | |
| 4 | 17363 | |
| 5 | 7765 | 6.6% |
| 6 | 3850 | 3.3% |
| 7 | 8633 | 7.3% |
| 8 | 1157 | 1.0% |
| 9 | 838 | 0.7% |
| 10 | 1135 | 1.0% |
| Value | Count | Frequency (%) |
| 20 | 14 | < 0.1% |
| 19 | 22 | < 0.1% |
| 18 | 35 | < 0.1% |
| 17 | 20 | < 0.1% |
| 16 | 40 | < 0.1% |
| 15 | 73 | 0.1% |
| 14 | 913 | |
| 13 | 140 | 0.1% |
| 12 | 223 | 0.2% |
| 11 | 395 |
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| df_index | hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | stay | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 2 | Resort Hotel | 0 | 7 | 2015 | 7 | 27 | 1 | 0 | 1 | 1 | 0 | 0 | BB | GBR | Direct | Direct | 0 | 0 | 0 | A | C | 0 | No Deposit | 0 | Transient | 75.0 | 0 | 0 | Check-Out | 2015-01-01 | 1 |
| 1 | 3 | Resort Hotel | 0 | 13 | 2015 | 7 | 27 | 1 | 0 | 1 | 1 | 0 | 0 | BB | GBR | Corporate | Corporate | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient | 75.0 | 0 | 0 | Check-Out | 2015-01-01 | 1 |
| 2 | 4 | Resort Hotel | 0 | 14 | 2015 | 7 | 27 | 1 | 0 | 2 | 2 | 0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient | 98.0 | 0 | 1 | Check-Out | 2015-01-01 | 2 |
| 3 | 5 | Resort Hotel | 0 | 14 | 2015 | 7 | 27 | 1 | 0 | 2 | 2 | 0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient | 98.0 | 0 | 1 | Check-Out | 2015-01-01 | 2 |
| 4 | 6 | Resort Hotel | 0 | 0 | 2015 | 7 | 27 | 1 | 0 | 2 | 2 | 0 | 0 | BB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0 | No Deposit | 0 | Transient | 107.0 | 0 | 0 | Check-Out | 2015-01-01 | 2 |
| 5 | 7 | Resort Hotel | 0 | 9 | 2015 | 7 | 27 | 1 | 0 | 2 | 2 | 0 | 0 | FB | PRT | Direct | Direct | 0 | 0 | 0 | C | C | 0 | No Deposit | 0 | Transient | 103.0 | 0 | 1 | Check-Out | 2015-01-01 | 2 |
| 6 | 8 | Resort Hotel | 1 | 85 | 2015 | 7 | 27 | 1 | 0 | 3 | 2 | 0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient | 82.0 | 0 | 1 | Canceled | 2015-01-01 | 3 |
| 7 | 9 | Resort Hotel | 1 | 75 | 2015 | 7 | 27 | 1 | 0 | 3 | 2 | 0 | 0 | HB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 0 | Transient | 105.5 | 0 | 0 | Canceled | 2015-01-01 | 3 |
| 8 | 10 | Resort Hotel | 1 | 23 | 2015 | 7 | 27 | 1 | 0 | 4 | 2 | 0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | E | E | 0 | No Deposit | 0 | Transient | 123.0 | 0 | 0 | Canceled | 2015-01-01 | 4 |
| 9 | 11 | Resort Hotel | 0 | 35 | 2015 | 7 | 27 | 1 | 0 | 4 | 2 | 0 | 0 | HB | PRT | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 0 | Transient | 145.0 | 0 | 0 | Check-Out | 2015-01-01 | 4 |
Last rows
| df_index | hotel | is_canceled | lead_time | arrival_date_year | arrival_date_month | arrival_date_week_number | arrival_date_day_of_month | stays_in_weekend_nights | stays_in_week_nights | adults | children | babies | meal | country | market_segment | distribution_channel | is_repeated_guest | previous_cancellations | previous_bookings_not_canceled | reserved_room_type | assigned_room_type | booking_changes | deposit_type | days_in_waiting_list | customer_type | adr | required_car_parking_spaces | total_of_special_requests | reservation_status | reservation_status_date | stay | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 117953 | 119380 | City Hotel | 0 | 44 | 2017 | 8 | 35 | 31 | 1 | 3 | 2 | 0 | 0 | SC | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient | 140.75 | 0 | 1 | Check-Out | 2017-01-01 | 4 |
| 117954 | 119381 | City Hotel | 0 | 188 | 2017 | 8 | 35 | 31 | 2 | 3 | 2 | 0 | 0 | BB | DEU | Direct | Direct | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient | 99.00 | 0 | 0 | Check-Out | 2017-01-01 | 5 |
| 117955 | 119382 | City Hotel | 0 | 135 | 2017 | 8 | 35 | 30 | 2 | 4 | 3 | 0 | 0 | BB | JPN | Online TA | TA/TO | 0 | 0 | 0 | G | G | 0 | No Deposit | 0 | Transient | 209.00 | 0 | 0 | Check-Out | 2017-01-01 | 6 |
| 117956 | 119383 | City Hotel | 0 | 164 | 2017 | 8 | 35 | 31 | 2 | 4 | 2 | 0 | 0 | BB | DEU | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient | 87.60 | 0 | 0 | Check-Out | 2017-01-01 | 6 |
| 117957 | 119384 | City Hotel | 0 | 21 | 2017 | 8 | 35 | 30 | 2 | 5 | 2 | 0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient | 96.14 | 0 | 2 | Check-Out | 2017-01-01 | 7 |
| 117958 | 119385 | City Hotel | 0 | 23 | 2017 | 8 | 35 | 30 | 2 | 5 | 2 | 0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient | 96.14 | 0 | 0 | Check-Out | 2017-01-01 | 7 |
| 117959 | 119386 | City Hotel | 0 | 102 | 2017 | 8 | 35 | 31 | 2 | 5 | 3 | 0 | 0 | BB | FRA | Online TA | TA/TO | 0 | 0 | 0 | E | E | 0 | No Deposit | 0 | Transient | 225.43 | 0 | 2 | Check-Out | 2017-01-01 | 7 |
| 117960 | 119387 | City Hotel | 0 | 34 | 2017 | 8 | 35 | 31 | 2 | 5 | 2 | 0 | 0 | BB | DEU | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 0 | Transient | 157.71 | 0 | 4 | Check-Out | 2017-01-01 | 7 |
| 117961 | 119388 | City Hotel | 0 | 109 | 2017 | 8 | 35 | 31 | 2 | 5 | 2 | 0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient | 104.40 | 0 | 0 | Check-Out | 2017-01-01 | 7 |
| 117962 | 119389 | City Hotel | 0 | 205 | 2017 | 8 | 35 | 29 | 2 | 7 | 2 | 0 | 0 | HB | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 0 | Transient | 151.20 | 0 | 2 | Check-Out | 2017-01-01 | 9 |